Statistics for Maintenance Modelling: Opening Excel Spreadsheets in Excel

# How to Configure Internet Explorer to open an Excel Spreadsheet in Excel¤

When you click on the HTML link to open the Microsoft Excel spreadsheet, you could find that Internet Explorer may open the file in itself, instead of opening the file in the Excel. This is the default configuration, but when this happens, you won't have access to the Excel menus and functions. Unless you are running Windows NT, to resolve this:

1. Open My Computer.
2. On the Tools menu, click Folder Options (in some versions, this may be Options from the View menu).
3. Click the File Types tab.
4. In the Registered file types list, click on the .XSL file format, (Microsoft Excel Worksheet), and then click Advanced (or Edit, or Change).
5. In the Edit File Type dialog box, click to clear the Browse in same window check box (or click to clear the Open Web documents in place checkbox).
6. Click OK.

If you are running Windows NT, you will have to edit the Windows registry instead. If you edit this incorrectly, this may cause serious problems and you do so at your own risk.

1. Start Registry Editor - Regedt32.exe in the windows\system32 folder.
2. Locate and then click the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Classes
3. Locate the subkey for Excel worksheets. To do this, search for the .xls subkey (associated with Excel worksheets) under the Classes key from step 2. Under this .xls subkey, the (default) value contains the subkey for your Excel worksheets e.g. "Excel.Sheet.8".
   Therefore, the full subkey for Microsoft Excel Worksheets would be the following:
   HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Sheet.8
4. Locate the registry key you identified in step 3
5. Modify the subkey by clicking on BrowserFlags and selecting Modify from the Edit menu.
   Add the following values for all subkeys apart from Excel.Sheet.5:
   1. Value name: BrowserFlags
      Data type: REG_DWORD
      Value: 8
      For Excel.Sheet.5 add the following value:
   2. Value name: BrowserFlags
      Data type: REG_DWORD
      Value: 9
6. Click OK, and then quit the Registry Editor.

Close